UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCNVbH0beogv1YE2T3lMulns7A32Jh6QzAIERv4ehCg='
WHERE
key_id = '8c10fa53be3a16ae89f8b4638f347396eafb212b968a6da4ea0b5d657eaf8ca2'
AND (
token = 'zCNVbH0beogv1YE2T3lMulns7A32Jh6QzAIERv4ehCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)