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