UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bznc3CDV7D4y6tl/CuTg3FgZChFp6T7Ls6TXjm9nKOA='
WHERE
key_id = '847b123ff95cf2cd709d69ee9051256a6060aca26325493814e0f923dc1a7c74'
AND (
token = 'bznc3CDV7D4y6tl/CuTg3FgZChFp6T7Ls6TXjm9nKOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)