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