UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGzm66gMHaW8xQ6nB6q1BATsrQZ7vUI4d7ZwMnJN0CQ='
WHERE
key_id = '1be6dd7240381c8c9b07c7b6095e0b2454bb5cbf135c53ebdde6b00604a7943b'
AND (
token = 'WGzm66gMHaW8xQ6nB6q1BATsrQZ7vUI4d7ZwMnJN0CQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)