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