UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htKYkOfShf0xKvcJKsLx/eA4izBc9NXpcghiuImHbmA='
WHERE
key_id = 'c489638878a27afc4ed0f573b272651c80aea0f9fe8780704554986fed4c0354'
AND (
token = 'htKYkOfShf0xKvcJKsLx/eA4izBc9NXpcghiuImHbmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)