UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8BmJjw5kNOsdVy1Fij8iUVA9lUsLGP/eAjODr3DbSKU='
WHERE
key_id = '5c895870157d3a28c229cd808a8684effb5ab8da6acbc980f6fe8559dc831b9f'
AND (
token = '8BmJjw5kNOsdVy1Fij8iUVA9lUsLGP/eAjODr3DbSKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)