UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l1AL6kKQ0WcHXSES6Y76n+EXb4iZPMrihDxUUlZaw64='
WHERE
key_id = '97d955bf70921776266f143e35574e719ee2c784cae7293c25d50ac57847dcc0'
AND (
token = 'l1AL6kKQ0WcHXSES6Y76n+EXb4iZPMrihDxUUlZaw64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)