UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MlFKmflnHNbMTrDT4/oSW3xzmmUtVPIWa5fV3skdCpU='
WHERE
key_id = '9359f2ab787a253842f881e93b2df233cf5875c892f59eb7089071a28b54f304'
AND (
token = 'MlFKmflnHNbMTrDT4/oSW3xzmmUtVPIWa5fV3skdCpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)