UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdT6EMEqtMyPa8MDbExW9k+W5hxM1U3YFQj1UqkMBWw='
WHERE
key_id = 'afc5444dcda911269d0ddec9b6dbe50a798e283f2da1b1b280be787efd6d5e35'
AND (
token = 'xdT6EMEqtMyPa8MDbExW9k+W5hxM1U3YFQj1UqkMBWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)