UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47g/C8wu4YRQ5uE7SdKCG6/tQ1qT6gtueJlbR2pXLF0='
WHERE
key_id = '3e8f27abe1ed4739b8f53470cd04d68a09735fad1564e151a4a3d70245c7ba98'
AND (
token = '47g/C8wu4YRQ5uE7SdKCG6/tQ1qT6gtueJlbR2pXLF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)