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