UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EAXjcdFIsmApOlu+9prZKtYyAGIRMxpgeIMrU8ZCD44='
WHERE
key_id = '0a8933e0a4beda1dc810d79f665c0fc088a2ca7e9aa5cc069fc0fdf4081ecf50'
AND (
token = 'EAXjcdFIsmApOlu+9prZKtYyAGIRMxpgeIMrU8ZCD44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)