UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PibrKQrPaI+Bmev2BdeEAXIPrE2pfeFVtHh+W7D0Im8='
WHERE
key_id = '9fb6fc40658326c04038cd483b418d7444d45068467b06778f2a63056b5def71'
AND (
token = 'PibrKQrPaI+Bmev2BdeEAXIPrE2pfeFVtHh+W7D0Im8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)