UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XAVy60fpLz80PhT/9TmUFX8KXYz7rtUNZW3+LXovmbA='
WHERE
key_id = '06a34a031818eea2bd358fd074732802749b25e55cf8d52daf4de568b4589ab5'
AND (
token = 'XAVy60fpLz80PhT/9TmUFX8KXYz7rtUNZW3+LXovmbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)