UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P9RGC2Rja12rCeIzVTCeiFCRTkW3M+WhwYPhWItXFy8='
WHERE
key_id = 'a016a664b37ed2256e9223358531948c8c68e1da95de804f111e9a6ce8c44d87'
AND (
token = 'P9RGC2Rja12rCeIzVTCeiFCRTkW3M+WhwYPhWItXFy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)