UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E8PilLGc+KVV3DpubPshtDjo47u/9IEqrTcDK6HDF2Y='
WHERE
key_id = '56ec5c5d33d18e0f41aae81de6ab0d3657e47823a4e289ee7beac85e36ca5dad'
AND (
token = 'E8PilLGc+KVV3DpubPshtDjo47u/9IEqrTcDK6HDF2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)