UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqwcJWehUzFBf2N81oym8Z5Iw4r9bWS66E4D3P23v3g='
WHERE
key_id = 'c95abc473b299a449552282827d62f479e8df68458eb04dde54d850a27dc9537'
AND (
token = 'XqwcJWehUzFBf2N81oym8Z5Iw4r9bWS66E4D3P23v3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)