UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3QMbA/f2LzsBE34w7mLvQayCO/qUU9gEVgt/R5nqPxE='
WHERE
key_id = '04c974a4ba363cb4011d60e809c26ca92b1043dc8bab650cd530c43c56dc05e5'
AND (
token = '3QMbA/f2LzsBE34w7mLvQayCO/qUU9gEVgt/R5nqPxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)