UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RS4cHHGnI9hDQQqylb50F6+7c6zmJ0GOp5nMn+ln48g='
WHERE
key_id = 'dd2b62459d1bf22ca09ca869b608d28a0526cb2b99be40edf13726156badbe46'
AND (
token = 'RS4cHHGnI9hDQQqylb50F6+7c6zmJ0GOp5nMn+ln48g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)