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