UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UDoACdV6hrzNADpCMkYkuH7P24I5Uz4E7DIiuCYZiUo='
WHERE
key_id = 'bcd47845e50b4cf986727b3d4b0b0615045ec600b5987b34ce0056e51e5c24d7'
AND (
token = 'UDoACdV6hrzNADpCMkYkuH7P24I5Uz4E7DIiuCYZiUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)