UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7U8JGv6wVzgcCi2PnR07Wm/YywUYeJ3x+staZGkHBVI='
WHERE
key_id = '42ce22c5493ce98344fa6d68c98575898006241a811c2679163f5e49e766b8b9'
AND (
token = '7U8JGv6wVzgcCi2PnR07Wm/YywUYeJ3x+staZGkHBVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)