UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e9n/CXYJsdL6ipX1IwB+W/Msvg7SxNXCqvUBr2OzCBg='
WHERE
key_id = 'd7c7f314f1624489fc6b3bb22de8d7573e7d362e9a5c04db08a5f294c3b5b5a9'
AND (
token = 'e9n/CXYJsdL6ipX1IwB+W/Msvg7SxNXCqvUBr2OzCBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)