UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzEYFjdNQr23Lq4SPly1ZPUFJdU4j+9G3IKCPq8VnYs='
WHERE
key_id = 'ac9712779708db43cb1470a495246e346d51fbed1852ae01d8f43f178c090d4a'
AND (
token = 'tzEYFjdNQr23Lq4SPly1ZPUFJdU4j+9G3IKCPq8VnYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)