UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hqFPy/L6ai934y3ePwU73SN4GF0Bqr9QZquSDDkjn0='
WHERE
key_id = 'a38a59337e70d4d17602034cf226440be4a649b85718f6aae6e9fe8d3f277b03'
AND (
token = '6hqFPy/L6ai934y3ePwU73SN4GF0Bqr9QZquSDDkjn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)