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