UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sT31vznwnYUQ8uBElgKPlMqFsDo8TCV8qiPUKu12cYA='
WHERE
key_id = '4e6015a0974060f0b71e74f2ea25e796873fa1ee51c2674c82c96de0d29cfbb7'
AND (
token = 'sT31vznwnYUQ8uBElgKPlMqFsDo8TCV8qiPUKu12cYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)